﻿CREATE PROCEDURE [dbo].[sp_UpdatePackage] 
    @templateId int, 
	@packageName nvarchar(256), 
	@packageVersion varchar(64),
	@packageBody xml,
	@changesFromTemplate xml
AS 
BEGIN

UPDATE Packages SET PackageVersion = @packageVersion, PackageBody = @packageBody, ChangesFromTemplate = @changesFromTemplate WHERE TemplateId = @templateId AND PackageName = @packageName;

END


